package com.wwwc.index.servlet;

import java.io.*;
import java.util.*;

public class UserInfoDetails implements Serializable {

    private String userName   = null;
    private int    userAge    = 0;
    private String userEmail  = null;
    private String firstName  = null;
    private String lastName   = null;
    private Date   joinDate   = null;
    private String userSex    = null;
    private String education  = null;
    private String userZip    = null;     
    private int    userLevel  = 0;
    private String signInTime = null;     
    private String signInIp   = null;     
    
    public UserInfoDetails (String name, int age, String email, String fname, String lname, Date join, String sex, 
			    String edu, String zip, int level, String time, String ip) {
	this.userName   = name;
	this.userAge    = age;
	this.userEmail  = email;
	this.firstName  = fname;
	this.lastName   = lname;
	this.joinDate   = join;
	this.userSex    = sex;
	this.education  = edu;
	this.userZip    = zip;     
	this.userLevel  = level;
	this.signInTime = time;     
	this.signInIp   = ip;     
    }

    public String getUserName() {
	return this.userName;
    }

    public int getUserAge() {
	return this.userAge;
    }
    
    public String getUserZip() {
	return this.userZip;
    }
    
    public int getUserLevel() {
	return this.userLevel;
    }

    /*
    public static String getCreateTableQuery() {
	StringBuffer sbf = new StringBuffer();
	sbf.append("CREATE TABLE USER_PROFILE (");
	sbf.append("USER_NAME VARCHAR_IGNORECASE(20),");
	sbf.append("USER_LEVEL INTEGER,");
	sbf.append("USER_ROLES VARCHAR(20),");
	sbf.append("LAST_NAME VARCHAR(20),");
	sbf.append("FIRST_NAME VARCHAR(20),");
	sbf.append("BIRTH_DAY TIMESTAMP,");
	sbf.append("ZIP_CODE VARCHAR_IGNORECASE(20),");
	sbf.append("EMAIL VARCHAR_IGNORECASE(100),");

	sbf.append("DATE TIMESTAMP,");
	sbf.append("TITLE VARCHAR(250),");
	sbf.append("USER VARCHAR_IGNORECASE(20),");
	sbf.append("TEXT VARCHAR_IGNORECASE(120000),");
	sbf.append("IMAGE VARCHAR_IGNORECASE(500),");
	sbf.append("LINK VARCHAR_IGNORECASE(500),");
	sbf.append("ALLOW_REPLY BIT,");
	sbf.append("ON_TOP BIT,");
	sbf.append("REMOVED BIT,");
	sbf.append("LAST_SIGN_IN_IP VARCHAR(20));");
	return sbf.toString();
    }
    */
}






